package com.example.demo.repository;

import com.example.demo.entity.Location.Location;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

public interface LocationRepository extends JpaRepository<Location, Integer> {

    @Query(value = "select wa_location_code from b_wa_location where working_center_code = :workingCenterCode and wa_location_name = :waLocationName", nativeQuery = true)
    String findCode(String workingCenterCode, String waLocationName);
}
